---
title: DB-CLL-047 — Insert a new legal case header record
summary: Insert a new legal case header record
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-047 — Insert a new legal case header record

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-047 |
| Operation type | I |
| Execution method | StoredProc |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Stored procedure call |
| Business object | clsLegalCase |
| Criteria property | InsertSQL |
| Lifecycle method | BeforeInsert |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | ReturnValue | NUMBER | N/A | New legal case identifier |
| ClaimID | Input | NUMBER | N/A | Claim number the legal case is associated with |
| CaseStatusCode | Input | VARCHAR2 | N/A | Current case status code |
| NatureCode | Input | VARCHAR2 | N/A | Nature/type of the legal case |
| FiledDate | Input | DATE | N/A | Date the case was filed |
| HearingLocationSeqNum | Input | NUMBER | N/A | Hearing location identifier |
| AttorneyLegalPersonSeqNum | Input | NUMBER | N/A | Assigned attorney legal-person identifier |
| AttorneyOtherFirmSeqNum | Input | NUMBER | N/A | Assigned attorney's firm identifier |
| AdjusterEmplid | Input | VARCHAR2 | N/A | Adjuster employee ID |
| ScheduleDate | Input | DATE | N/A | Scheduled hearing date |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [LEGAL_CASE](../database-tables.md#legal_case) | INSERT | ~39 columns |

## Sample SQL

```sql
EXEC pk80001_legalnet.InsertLegalCase(:LegalCaseID OUT, :ClaimID, :CaseStatusCode, :NatureCode,
  :FiledDate, :HearingLocationSeqNum, :AttorneyLegalPersonSeqNum, :AttorneyOtherFirmSeqNum,
  :AdjusterEmplid, :ScheduleDate, :ReviewLevelCode, :RequestTypeCode, :RequestedByCode,
  :OrderTypeCode, :PetitionerRespondentCode, :MailDate, :MailOARFlag, :FileCreateDate,
  :HearingSeqNum, :CreateUser, :CreateDate, :CaseTypeCode, :AppealFlag, :ConsolidatedFlag,
  :CommentText, :DecisionDate, :DecisionCode, :ExtensionDate, :OARFlag, :OARDate,
  :SecretaryEmplid, :ALJLegalPersonSeqNum, :ClosedDate, :ClosedFlag, :PriorityFlag,
  :ExpeditedFlag, :LastActivityDate, :ReconIssueFlag, :OtherStatusText);  -- final 21 params inferred from remaining legal-case detail columns*; proc name inferred*
```

## Operations and processes

- [Manage legal case lifecycle](../operations/manage-legal-case.md)

## Business rules

- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsLegalCase.vb`